Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

OpenEdge database objects and MSS database objects

The OpenEdge database and the MS SQL Server database share the structural elements common to relational databases, but each system has its own elements. These elements, called database or data source objects, are components of the OpenEdge database or MSS databases’s logical structure. Table 2–1 lists OpenEdge database objects and the MSS database equivalents.

Table 2–1: OpenEdge Database objects and MSS database objects

OpenEdge	MS SQL Server
Table/File	Table
Field	Column
Record	Row
Index	Index
Unique index	Primary key
Nonunique index	Foreign key
Sequences	Native equivalent1
Validation expression	Integrity constraint
Validation message	No equivalent
Initial value	Default
Schema trigger.	Trigger.
No equivalent to stored procedures.	Stored procedure.
View.	View.

1The DataServer supports OpenEdge sequences through native stored procedures and triggers.